﻿CREATE TABLE [dbo].[Fee] (
    [ID]                   INT             IDENTITY (1, 1) NOT NULL,
    [ImportId]             INT             NOT NULL,
    [ExchangeFee1]         DECIMAL (18, 2) NULL,
    [ShippingFee1]         DECIMAL (18, 2) NULL,
    [ShippingFee2]         DECIMAL (18, 2) NULL,
    [CustomsFee1]          DECIMAL (18, 2) NULL,
    [CustomsFee2]          DECIMAL (18, 2) NULL,
    [BlockFee]             DECIMAL (18, 2) NULL,
    [InsuranceFee]         DECIMAL (18, 2) NULL,
    [TariffFee]            DECIMAL (18, 2) NULL,
    [LateFee]              DECIMAL (18, 2) NULL,
    [ThreeCheckFee]        DECIMAL (18, 2) NULL,
    [BoxCheckFee]          DECIMAL (18, 2) NULL,
    [ExaminationFee]       DECIMAL (18, 2) NULL,
    [DisinfectionFee]      DECIMAL (18, 2) NULL,
    [CustomsCheckFee]      DECIMAL (18, 2) NULL,
    [ArrangeProductFee]    DECIMAL (18, 2) NULL,
    [PortOtherFee]         DECIMAL (18, 2) NULL,
    [PutBoxFee]            DECIMAL (18, 2) NULL,
    [LeaveFee]             DECIMAL (18, 2) NULL,
    [ExpiredFee]           DECIMAL (18, 2) NULL,
    [BrokenBoxFee]         DECIMAL (18, 2) NULL,
    [ChangeBoxDoorFee]     DECIMAL (18, 2) NULL,
    [FumigationFee]        DECIMAL (18, 2) NULL,
    [KillBugFee]           DECIMAL (18, 2) NULL,
    [LeaseBoxFee]          DECIMAL (18, 2) NULL,
    [WarehouseFee]         DECIMAL (18, 2) NULL,
    [TransportFee1]        DECIMAL (18, 2) NULL,
    [TransportFee2]        DECIMAL (18, 2) NULL,
    [AnimalHealthCheckFee] DECIMAL (18, 2) NULL,
    [AnimalBoxCheckFee]    DECIMAL (18, 2) NULL,
    [ClearBoxFee]          DECIMAL (18, 2) NULL,
    [ChangePlanFee]        DECIMAL (18, 2) NULL,
    [AgentFee]             DECIMAL (18, 2) NULL,
    [TypeBillFee]          DECIMAL (18, 2) NULL,
    [TakeBillFee]          DECIMAL (18, 2) NULL,
    [ExpressionFee]        DECIMAL (18, 2) NULL,
    [DoneFee]              DECIMAL (18, 2) NULL,
    [WaitingFee]           DECIMAL (18, 2) NULL,
    [InternalTransportFee] DECIMAL (18, 2) NULL,
    [ExchangeBoxFee]       DECIMAL (18, 2) NULL,
    [FairEmployeeFee]      DECIMAL (18, 2) NULL,
    [CommissionFee]        DECIMAL (18, 2) NULL,
    [MoneyExchangeFee]     DECIMAL (18, 2) NULL,
    [Receiptable]          DECIMAL (18, 2) NULL,
    [CreatedDate]          DATETIME        NOT NULL,
    [CreatedBy]            INT             NOT NULL,
    [ModifiedDate]         DATETIME        NOT NULL,
    [ModifiedBy]           INT             NOT NULL
);

